Flyway Reports
Migration report
Database version: 2
2 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.766s
Database version: 2
2 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.766s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
1 init Versioned SQL V1__init.sql 00:00.234s
2 remove risk level table and create supply Versioned SQL V2__remove_risk_level_table_and_create_supply.sql 00:00.532s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
You can read more about the migrate report here

No migrations found

Flyway Exception: Migration V1__init.sql failed
-----------------------------
SQL State  : 42S01
Error Code : 1050
Message    : (conn=2199) Table 'flyway_schema_history' already exists
Location   : src\main\resources\db\migration\V1__init.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V1__init.sql)
Line       : 59
Statement  : CREATE TABLE flyway_schema_history
(
    installed_rank INT                     NOT NULL,
    version        VARCHAR(50)             NULL,
    `description`  VARCHAR(200)            NOT NULL,
    type           VARCHAR(20)             NOT NULL,
    script         VARCHAR(1000)           NOT NULL,
    checksum       INT       DEFAULT NULL  NULL,
    installed_by   VARCHAR(100)            NOT NULL,
    installed_on   timestamp DEFAULT NOW() NOT NULL,
    execution_time INT                     NOT NULL,
    success        BIT                     NOT NULL,
    CONSTRAINT PK_FLYWAY_SCHEMA_HISTORY PRIMARY KEY (installed_rank)
)
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.175s
Database version: 1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.175s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
1 init Versioned SQL V1__init.sql 00:00.175s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.199s
Database version: 1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.199s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
1 init setup Versioned SQL V1__init_setup.sql 00:00.199s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.194s
Database version: 1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.194s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
1 init setup Versioned SQL V1__init_setup.sql 00:00.194s
Flyway Exception: Migration V2__setup_v2.sql failed
---------------------------------
SQL State  : HY000
Error Code : 1005
Message    : (conn=268) Can't create table `mdm_equipment`.`supplies` (errno: 121 "Duplicate key on write or update")
Location   : src\main\resources\db\migration\V2__setup_v2.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V2__setup_v2.sql)
Line       : 160
Statement  : ALTER TABLE supplies
    ADD CONSTRAINT PROJECT FOREIGN KEY (project_id) REFERENCES projects (id) ON UPDATE RESTRICT ON DELETE SET NULL
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.192s
Database version: 1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.192s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
1 init setup Versioned SQL V1__init_setup.sql 00:00.192s
Flyway Exception: Migration V2__setup_v2.sql failed
---------------------------------
SQL State  : 42000
Error Code : 1091
Message    : (conn=270) Can't DROP FOREIGN KEY `FK5sej5ndcwkmq5flmhwqksppkh`; check that it exists
Location   : src\main\resources\db\migration\V2__setup_v2.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V2__setup_v2.sql)
Line       : 160
Statement  : ALTER TABLE equipment_supply
    DROP FOREIGN KEY FK5sej5ndcwkmq5flmhwqksppkh
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.370s
Database version: 1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.370s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
1 Versioned SQL V1__.sql 00:00.370s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 2
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.079s
Database version: 2
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.079s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
2 create supplier table Versioned SQL V2__create_supplier_table.sql 00:00.079s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 2
2 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.454s
Database version: 2
2 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.454s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
1 Versioned SQL V1__.sql 00:00.395s
2 create supplier table Versioned SQL V2__create_supplier_table.sql 00:00.059s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 3
3 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.584s
Database version: 3
3 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.584s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
1 Versioned SQL V1__.sql 00:00.463s
2 create supplier table Versioned SQL V2__create_supplier_table.sql 00:00.069s
3 create repair table Versioned SQL V3__create_repair_table.sql 00:00.052s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 4
4 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.831s
Database version: 4
4 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.831s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
1 Versioned SQL V1__.sql 00:00.454s
2 create supplier table Versioned SQL V2__create_supplier_table.sql 00:00.069s
3 create repair table Versioned SQL V3__create_repair_table.sql 00:00.098s
4 Versioned SQL V4__.sql 00:00.210s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 2
2 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.438s
Database version: 2
2 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.438s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
1 Versioned SQL V1__.sql 00:00.377s
2 create supplier table Versioned SQL V2__create_supplier_table.sql 00:00.061s
Flyway Exception: Migration V3__create_repair_table.sql failed
--------------------------------------------
SQL State  : HY000
Error Code : 1005
Message    : (conn=459) Can't create table `mdm_equipment`.`repairs` (errno: 150 "Foreign key constraint is incorrectly formed")
Location   : src\main\resources\db\migration\V3__create_repair_table.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V3__create_repair_table.sql)
Line       : 28
Statement  : ALTER TABLE repairs
    ADD CONSTRAINT FK_REPAIRS_ON_REPAIR_COMPANY FOREIGN KEY (repair_company_id) REFERENCES suppliers (id) ON UPDATE RESTRICT ON DELETE SET NULL
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.643s
Database version: 1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.643s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
1 Versioned SQL V1__.sql 00:00.643s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
You can read more about the migrate report here

No migrations found

Flyway Exception: Migration V1__.sql failed
-------------------------
SQL State  : HY000
Error Code : 1005
Message    : (conn=467) Can't create table `mdm_equipment`.`repairs` (errno: 150 "Foreign key constraint is incorrectly formed")
Location   : src\main\resources\db\migration\V1__.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V1__.sql)
Line       : 351
Statement  : ALTER TABLE repairs
    ADD CONSTRAINT FK_REPAIRS_ON_REPAIR_COMPANY FOREIGN KEY (repair_company_id) REFERENCES suppliers (id) ON UPDATE RESTRICT ON DELETE SET NULL
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.580s
Database version: 1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.580s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
1 Versioned SQL V1__.sql 00:00.580s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.569s
Database version: 1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.569s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
1 Versioned SQL V1__.sql 00:00.569s
Flyway Exception: Migration V2__.sql failed
-------------------------
SQL State  : HY000
Error Code : 1005
Message    : (conn=12) Can't create table `mdm_equipment`.`users` (errno: 150 "Foreign key constraint is incorrectly formed")
Location   : src\main\resources\db\migration\V2__.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V2__.sql)
Line       : 65
Statement  : ALTER TABLE users
    ADD CONSTRAINT DEPARTMENT FOREIGN KEY (department_id) REFERENCES departments (id) ON UPDATE RESTRICT ON DELETE SET NULL
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 2
2 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.789s
Database version: 2
2 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.789s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
1 Versioned SQL V1__.sql 00:00.550s
2 Versioned SQL V2__.sql 00:00.239s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 3
3 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.948s
Database version: 3
3 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.948s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
1 Versioned SQL V1__.sql 00:00.609s
2 Versioned SQL V2__.sql 00:00.271s
3 add service table and provider provides services table Versioned SQL V3__add service table and provider_provides_services table.sql 00:00.068s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 3
3 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.881s
Database version: 3
3 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.881s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
1 Versioned SQL V1__.sql 00:00.563s
2 Versioned SQL V2__.sql 00:00.247s
3 add service table and provider provides services table Versioned SQL V3__add service table and provider_provides_services table.sql 00:00.071s
Flyway Exception: Migration V3_1__.sql failed
---------------------------
SQL State  : HY000
Error Code : 1553
Message    : (conn=200) Cannot drop index 'FK_HANDOVERS_ON_DEPARTMENT': needed in a foreign key constraint
Location   : src\main\resources\db\migration\V3_1__.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V3_1__.sql)
Line       : 4
Statement  : ALTER TABLE handovers
    DROP COLUMN department_id
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 3
3 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.898s
Database version: 3
3 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.898s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
1 Versioned SQL V1__.sql 00:00.562s
2 Versioned SQL V2__.sql 00:00.265s
3 add service table and provider provides services table Versioned SQL V3__add service table and provider_provides_services table.sql 00:00.071s
Flyway Exception: Migration V3_1__.sql failed
---------------------------
SQL State  : HY000
Error Code : 1828
Message    : (conn=204) Cannot drop column 'department_id': needed in a foreign key constraint 'mdm_equipment/FK_HANDOVERS_ON_DEPARTMENT'
Location   : src\main\resources\db\migration\V3_1__.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V3_1__.sql)
Line       : 5
Statement  : ALTER TABLE handovers
    DROP COLUMN department_id
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 3
3 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.923s
Database version: 3
3 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.923s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
1 Versioned SQL V1__.sql 00:00.566s
2 Versioned SQL V2__.sql 00:00.288s
3 add service table and provider provides services table Versioned SQL V3__add service table and provider_provides_services table.sql 00:00.069s
Flyway Exception: Migration V3_1__.sql failed
---------------------------
SQL State  : HY000
Error Code : 1828
Message    : (conn=208) Cannot drop column 'department_id': needed in a foreign key constraint 'mdm_equipment/FK_HANDOVERS_ON_DEPARTMENT'
Location   : src\main\resources\db\migration\V3_1__.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V3_1__.sql)
Line       : 5
Statement  : ALTER TABLE handovers
    DROP COLUMN department_id
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
You can read more about the migrate report here

No migrations found

Flyway Exception: Migration V1__.sql failed
-------------------------
SQL State  : HY000
Error Code : 1005
Message    : (conn=212) Can't create table `mdm_equipment`.`users` (errno: 150 "Foreign key constraint is incorrectly formed")
Location   : src\main\resources\db\migration\V1__.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V1__.sql)
Line       : 387
Statement  : ALTER TABLE users
    ADD CONSTRAINT DEPARTMENT FOREIGN KEY (department_id) REFERENCES departments (id) ON UPDATE CASCADE ON DELETE SET NULL
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
You can read more about the migrate report here

No migrations found

Flyway Exception: Migration V1__.sql failed
-------------------------
SQL State  : HY000
Error Code : 1005
Message    : (conn=217) Can't create table `mdm_equipment`.`handovers` (errno: 150 "Foreign key constraint is incorrectly formed")
Location   : src\main\resources\db\migration\V1__.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V1__.sql)
Line       : 411
Statement  : ALTER TABLE handovers
    ADD CONSTRAINT FK_HANDOVERS_ON_DEPARTMENT FOREIGN KEY (department_id) REFERENCES departments (id) ON UPDATE CASCADE ON DELETE SET NULL
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
You can read more about the migrate report here

No migrations found

Flyway Exception: Migration V1__.sql failed
-------------------------
SQL State  : HY000
Error Code : 1005
Message    : (conn=220) Can't create table `mdm_equipment`.`handovers` (errno: 150 "Foreign key constraint is incorrectly formed")
Location   : src\main\resources\db\migration\V1__.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V1__.sql)
Line       : 411
Statement  : ALTER TABLE handovers
    ADD CONSTRAINT FK_HANDOVERS_ON_DEPARTMENT FOREIGN KEY (department_id) REFERENCES departments (id) ON UPDATE CASCADE ON DELETE SET NULL
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
You can read more about the migrate report here

No migrations found

Flyway Exception: Migration V1__.sql failed
-------------------------
SQL State  : HY000
Error Code : 1005
Message    : (conn=223) Can't create table `mdm_equipment`.`handovers` (errno: 150 "Foreign key constraint is incorrectly formed")
Location   : src\main\resources\db\migration\V1__.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V1__.sql)
Line       : 417
Statement  : ALTER TABLE handovers
    ADD CONSTRAINT FK_HANDOVERS_ON_RESPONSIBLE_PERSON FOREIGN KEY (responsible_person_id) REFERENCES users (id) ON UPDATE CASCADE ON DELETE SET NULL
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
You can read more about the migrate report here

No migrations found

Flyway Exception: Migration V1__.sql failed
-------------------------
SQL State  : HY000
Error Code : 1005
Message    : (conn=226) Can't create table `mdm_equipment`.`inventories` (errno: 150 "Foreign key constraint is incorrectly formed")
Location   : src\main\resources\db\migration\V1__.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V1__.sql)
Line       : 426
Statement  : ALTER TABLE inventories
    ADD CONSTRAINT FK_INVENTORIES_ON_INVENTORY_PERSON FOREIGN KEY (inventory_person_id) REFERENCES users (id) ON UPDATE CASCADE ON DELETE SET NULL
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
You can read more about the migrate report here

No migrations found

Flyway Exception: Migration V1__.sql failed
-------------------------
SQL State  : HY000
Error Code : 1005
Message    : (conn=229) Can't create table `mdm_equipment`.`repairs` (errno: 150 "Foreign key constraint is incorrectly formed")
Location   : src\main\resources\db\migration\V1__.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V1__.sql)
Line       : 450
Statement  : ALTER TABLE repairs
    ADD CONSTRAINT FK_REPAIRS_ON_REPORTING_PERSON FOREIGN KEY (reporting_person_id) REFERENCES users (id) ON UPDATE CASCADE ON DELETE SET NULL
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
You can read more about the migrate report here

No migrations found

Flyway Exception: Migration V1__.sql failed
-------------------------
SQL State  : HY000
Error Code : 1005
Message    : (conn=232) Can't create table `mdm_equipment`.`suppliers` (errno: 150 "Foreign key constraint is incorrectly formed")
Location   : src\main\resources\db\migration\V1__.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V1__.sql)
Line       : 453
Statement  : ALTER TABLE suppliers
    ADD CONSTRAINT FK_SUPPLIERS_ON_CONTACT_PERSON FOREIGN KEY (contact_person_id) REFERENCES users (id) ON UPDATE CASCADE ON DELETE SET NULL
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
You can read more about the migrate report here

No migrations found

Flyway Exception: Migration V1__.sql failed
-------------------------
SQL State  : HY000
Error Code : 1005
Message    : (conn=235) Can't create table `mdm_equipment`.`transfers` (errno: 150 "Foreign key constraint is incorrectly formed")
Location   : src\main\resources\db\migration\V1__.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V1__.sql)
Line       : 477
Statement  : ALTER TABLE transfers
    ADD CONSTRAINT FK_TRANSFERS_ON_FROM_DEPARTMENT FOREIGN KEY (from_department_id) REFERENCES departments (id) ON UPDATE CASCADE ON DELETE SET NULL
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
You can read more about the migrate report here

No migrations found

Flyway Exception: Migration V1__.sql failed
-------------------------
SQL State  : HY000
Error Code : 1005
Message    : (conn=238) Can't create table `mdm_equipment`.`provider_provides_services` (errno: 150 "Foreign key constraint is incorrectly formed")
Location   : src\main\resources\db\migration\V1__.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V1__.sql)
Line       : 498
Statement  : ALTER TABLE provider_provides_services
    ADD CONSTRAINT fk_proproser_on_service FOREIGN KEY (service_id) REFERENCES services (id) ON UPDATE CASCADE ON DELETE SET NULL
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.964s
Database version: 1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.964s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
1 Versioned SQL V1__.sql 00:00.964s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 1.1
2 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:01.004s
Database version: 1.1
2 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:01.004s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
1 Versioned SQL V1__.sql 00:00.993s
1.1 Versioned SQL V1_1__.sql 00:00.011s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 1.1
2 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.942s
Database version: 1.1
2 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.942s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
1 Versioned SQL V1__.sql 00:00.931s
1.1 Versioned SQL V1_1__.sql 00:00.011s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 2
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.027s
Database version: 2
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.027s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
2 add file storage table Versioned SQL V2__add file storage table.sql 00:00.027s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 2.1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.129s
Database version: 2.1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.129s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
2.1 remove created at and updated at Versioned SQL V2_1__ remove created at and updated at.sql 00:00.129s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 2.2
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.031s
Database version: 2.2
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.031s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
2.2 rename acceptance date to approval date Versioned SQL V2_2__ rename acceptance_date to approval_date.sql 00:00.031s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
You can read more about the migrate report here

No migrations found

Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 2.4
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.045s
Database version: 2.4
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.045s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
2.4 create equipment user table Versioned SQL V2_4__ create equipment_user table.sql 00:00.045s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 2.5
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.026s
Database version: 2.5
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.026s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
2.5 Versioned SQL V2_5__.sql 00:00.026s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 2.6
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.012s
Database version: 2.6
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.012s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
2.6 remove image field in repair table Versioned SQL V2.6__remove image field in repair table.sql 00:00.012s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 2.7
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.028s
Database version: 2.7
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.028s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
2.7 change associated entity id type from string to long Versioned SQL V2_7__ change associated entity id type from string to long.sql 00:00.028s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 2.8
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.023s
Database version: 2.8
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.023s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
2.8 add content type in file storage table Versioned SQL V2_8__ add content type in file storage table.sql 00:00.023s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 2.8
11 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:01.411s
Database version: 2.8
11 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:01.411s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
1 Versioned SQL V1__.sql 00:01.085s
1.1 Versioned SQL V1_1__.sql 00:00.014s
2 add file storage table Versioned SQL V2__add file storage table.sql 00:00.010s
2.1 remove created at and updated at Versioned SQL V2_1__ remove created at and updated at.sql 00:00.122s
2.2 rename acceptance date to approval date Versioned SQL V2_2__ rename acceptance_date to approval_date.sql 00:00.019s
2.3 remove equipment status and handover status from handovers table Versioned SQL V2_3__ remove equipment_status and handover_status from handovers table.sql 00:00.021s
2.4 create equipment user table Versioned SQL V2_4__ create equipment_user table.sql 00:00.034s
2.5 Versioned SQL V2_5__.sql 00:00.025s
2.6 remove image field in repair table Versioned SQL V2.6__remove image field in repair table.sql 00:00.011s
2.7 change associated entity id type from string to long Versioned SQL V2_7__ change associated entity id type from string to long.sql 00:00.019s
2.8 add content type in file storage table Versioned SQL V2_8__ add content type in file storage table.sql 00:00.051s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
You can read more about the migrate report here

No migrations found

Flyway Exception: Migration V2_9__add password filed in users table.sql failed
------------------------------------------------------------
SQL State  : 01000
Error Code : 1265
Message    : (conn=1604) Data truncated for column 'password' at row 1
Location   : src\main\resources\db\migration\V2_9__add password filed in users table.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V2_9__add password filed in users table.sql)
Line       : 4
Statement  : ALTER TABLE users
    MODIFY password VARCHAR(255) NOT NULL
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
You can read more about the migrate report here

No migrations found

Flyway Exception: Migration V2_9__ add password field to user table.sql failed
------------------------------------------------------------
SQL State  : 42S21
Error Code : 1060
Message    : (conn=1610) Duplicate column name 'password'
Location   : src\main\resources\db\migration\V2_9__ add password field to user table.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V2_9__ add password field to user table.sql)
Line       : 1
Statement  : ALTER TABLE users
    ADD password VARCHAR(255) NULL
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 2.9
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.029s
Database version: 2.9
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.029s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
2.9 add password field to user table Versioned SQL V2_9__ add password field to user table.sql 00:00.029s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 3
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.061s
Database version: 3
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.061s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
3 add forgot password table Versioned SQL V3__ add forgot password table.sql 00:00.061s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 3.1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.031s
Database version: 3.1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.031s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
3.1 Versioned SQL V3_1__.sql 00:00.031s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 3.3
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.035s
Database version: 3.3
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.035s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
3.3 remove inventory status Versioned SQL V3_3__ remove inventory status.sql 00:00.035s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 4
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.040s
Database version: 4
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.040s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
4 add equipment group table Versioned SQL V4__add equipment group table.sql 00:00.040s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 4.1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.082s
Database version: 4.1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.082s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
4.1 update not null constraint on equipment categories table and equipment groups table Versioned SQL V4_1__update not null constraint on equipment categories table and equipment groups table.sql 00:00.082s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 4.2
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.035s
Database version: 4.2
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.035s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
4.2 Versioned SQL V4_2__.sql 00:00.035s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 4.3
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.011s
Database version: 4.3
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.011s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
4.3 drop unique on alias in equipment categories table Versioned SQL V4_3__drop unique on alias in equipment categories table.sql 00:00.011s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 5
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.061s
Database version: 5
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.061s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
5 create equipment unit table Versioned SQL V5__create equipment unit table.sql 00:00.061s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
You can read more about the migrate report here

No migrations found

Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 5.1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.011s
Database version: 5.1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.011s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
5.1 drop unique constraint on hash code Versioned SQL V5_1__drop unique constraint on hash_code.sql 00:00.011s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 5.2
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.058s
Database version: 5.2
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.058s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
5.2 add created by in handovers table Versioned SQL V5_2__ add created by in handovers table.sql 00:00.058s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 5.4
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.038s
Database version: 5.4
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.038s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
5.4 add approval on handover table Versioned SQL V5_4__add approval on handover table.sql 00:00.038s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
You can read more about the migrate report here

No migrations found

Flyway Exception: Migration V5_5__add approval on handover table.sql failed
---------------------------------------------------------
SQL State  : 42S21
Error Code : 1060
Message    : (conn=246) Duplicate column name 'approval_date'
Location   : src\main\resources\db\migration\V5_5__add approval on handover table.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V5_5__add approval on handover table.sql)
Line       : 1
Statement  : ALTER TABLE handovers
    ADD approval_date date NULL
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
You can read more about the migrate report here

No migrations found

Flyway Exception: Migration V5_5__add approval on handover table.sql failed
---------------------------------------------------------
SQL State  : 42S21
Error Code : 1060
Message    : (conn=249) Duplicate column name 'approval_date'
Location   : src\main\resources\db\migration\V5_5__add approval on handover table.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V5_5__add approval on handover table.sql)
Line       : 1
Statement  : ALTER TABLE handovers
    ADD approval_date date NULL
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 5.5
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.035s
Database version: 5.5
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.035s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
5.5 add approval on handover table Versioned SQL V5_5__add approval on handover table.sql 00:00.035s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 6
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.042s
Database version: 6
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.042s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
6 remove equipment user many to many relationship Versioned SQL V6__remove equipment user many to many relationship.sql 00:00.042s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 7
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.087s
Database version: 7
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.087s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
7 add notification, notification config and user read notification table Versioned SQL V7__add notification, notification config and user read notification table.sql 00:00.087s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 7.1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.013s
Database version: 7.1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.013s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
7.1 modify notifications content from text to json Versioned SQL V7_1__modify notifications content from text to json.sql 00:00.013s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 7.2
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.018s
Database version: 7.2
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.018s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
7.2 add note filed to handovers table Versioned SQL V7_2__ add note filed to handovers table.sql 00:00.018s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 7.3
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.113s
Database version: 7.3
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.113s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
7.3 alter notification and notification config table Versioned SQL V7_3__ alter notification and notification config table.sql 00:00.113s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 7.4
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.074s
Database version: 7.4
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.074s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
7.4 add note and status on handovers table Versioned SQL V7_4__ add note and status on handovers table.sql 00:00.074s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 8
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.319s
Database version: 8
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.319s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
8 modify all data type from date to datetime Versioned SQL V8__ modify all data type from date to datetime.sql 00:00.319s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
You can read more about the migrate report here

No migrations found

Flyway Exception: Migration V9__add repair ticket, broken report ticket, ticket processes, add not null constraint on some  local date time data type.sql failed
----------------------------------------------------------------------------------------------------------------------------------------------
SQL State  : 42000
Error Code : 1072
Message    : (conn=79) Key column '' doesn't exist in table
Location   : src\main\resources\db\migration\V9__add repair ticket, broken report ticket, ticket processes, add not null constraint on some  local date time data type.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V9__add repair ticket, broken report ticket, ticket processes, add not null constraint on some  local date time data type.sql)
Line       : 54
Statement  : ALTER TABLE broken_report_tickets
    ADD CONSTRAINT code UNIQUE (``)
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
You can read more about the migrate report here

No migrations found

Flyway Exception: Migration V9__add repair ticket, broken report ticket, ticket processes, add not null constraint on some  local date time data type.sql failed
----------------------------------------------------------------------------------------------------------------------------------------------
SQL State  : 42S01
Error Code : 1050
Message    : (conn=87) Table 'broken_report_ticket_processes' already exists
Location   : src\main\resources\db\migration\V9__add repair ticket, broken report ticket, ticket processes, add not null constraint on some  local date time data type.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V9__add repair ticket, broken report ticket, ticket processes, add not null constraint on some  local date time data type.sql)
Line       : 1
Statement  : CREATE TABLE broken_report_ticket_processes
(
    id                      BIGINT AUTO_INCREMENT NOT NULL,
    creator_id              BIGINT                NULL,
    created_date            datetime              NOT NULL,
    creator_note            TEXT                  NULL,
    approval_date           datetime              NULL,
    approver_note           TEXT                  NULL,
    approver_id             BIGINT                NULL,
    is_accepted             BIT(1)                NULL,
    broken_report_ticket_id BIGINT                NOT NULL,
    CONSTRAINT pk_broken_report_ticket_processes PRIMARY KEY (id)
)
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 9
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.363s
Database version: 9
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.363s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
9 add repair ticket, broken report ticket, ticket processes, add not null constraint on some local date time data type Versioned SQL V9__add repair ticket, broken report ticket, ticket processes, add not null constraint on some local date time data type.sql 00:00.363s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 10
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.261s
Database version: 10
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.261s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
10 drop all ticket processes table Versioned SQL V10__ drop all ticket processes table.sql 00:00.261s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 3
13 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:01.382s
Database version: 3
13 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:01.382s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
1 Versioned SQL V1__.sql 00:00.900s
1.1 Versioned SQL V1_1__.sql 00:00.011s
2 add file storage table Versioned SQL V2__add file storage table.sql 00:00.017s
2.1 remove created at and updated at Versioned SQL V2_1__ remove created at and updated at.sql 00:00.163s
2.2 rename acceptance date to approval date Versioned SQL V2_2__ rename acceptance_date to approval_date.sql 00:00.020s
2.3 remove equipment status and handover status from handovers table Versioned SQL V2_3__ remove equipment_status and handover_status from handovers table.sql 00:00.022s
2.4 create equipment user table Versioned SQL V2_4__ create equipment_user table.sql 00:00.046s
2.5 Versioned SQL V2_5__.sql 00:00.027s
2.6 remove image field in repair table Versioned SQL V2.6__remove image field in repair table.sql 00:00.012s
2.7 change associated entity id type from string to long Versioned SQL V2_7__ change associated entity id type from string to long.sql 00:00.020s
2.8 add content type in file storage table Versioned SQL V2_8__ add content type in file storage table.sql 00:00.034s
2.9 add password field to user table Versioned SQL V2_9__ add password field to user table.sql 00:00.083s
3 add forgot password table Versioned SQL V3__ add forgot password table.sql 00:00.027s
Flyway Exception: Migration V3_1__.sql failed
---------------------------
SQL State  : 42S22
Error Code : 1054
Message    : (conn=216) Unknown column 'otp' in 'forgot_password'
Location   : src\main\resources\db\migration\V3_1__.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V3_1__.sql)
Line       : 1
Statement  : ALTER TABLE forgot_password
    CHANGE otp uuid VARCHAR(255)
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 5.5
23 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:01.755s
Database version: 5.5
23 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:01.755s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
1 Versioned SQL V1__.sql 00:00.987s
1.1 Versioned SQL V1_1__.sql 00:00.011s
2 add file storage table Versioned SQL V2__add file storage table.sql 00:00.007s
2.1 remove created at and updated at Versioned SQL V2_1__ remove created at and updated at.sql 00:00.124s
2.2 rename acceptance date to approval date Versioned SQL V2_2__ rename acceptance_date to approval_date.sql 00:00.019s
2.3 remove equipment status and handover status from handovers table Versioned SQL V2_3__ remove equipment_status and handover_status from handovers table.sql 00:00.020s
2.4 create equipment user table Versioned SQL V2_4__ create equipment_user table.sql 00:00.036s
2.5 Versioned SQL V2_5__.sql 00:00.033s
2.6 remove image field in repair table Versioned SQL V2.6__remove image field in repair table.sql 00:00.012s
2.7 change associated entity id type from string to long Versioned SQL V2_7__ change associated entity id type from string to long.sql 00:00.037s
2.8 add content type in file storage table Versioned SQL V2_8__ add content type in file storage table.sql 00:00.035s
2.9 add password field to user table Versioned SQL V2_9__ add password field to user table.sql 00:00.085s
3 add forgot password table Versioned SQL V3__ add forgot password table.sql 00:00.055s
3.3 remove inventory status Versioned SQL V3_3__ remove inventory status.sql 00:00.017s
4 add equipment group table Versioned SQL V4__add equipment group table.sql 00:00.028s
4.1 update not null constraint on equipment categories table and equipment groups table Versioned SQL V4_1__update not null constraint on equipment categories table and equipment groups table.sql 00:00.078s
4.2 Versioned SQL V4_2__.sql 00:00.025s
4.3 drop unique on alias in equipment categories table Versioned SQL V4_3__drop unique on alias in equipment categories table.sql 00:00.009s
5 create equipment unit table Versioned SQL V5__create equipment unit table.sql 00:00.030s
5.1 drop unique constraint on hash code Versioned SQL V5_1__drop unique constraint on hash_code.sql 00:00.011s
5.2 add created by in handovers table Versioned SQL V5_2__ add created by in handovers table.sql 00:00.040s
5.4 remove document column on handovers and transfers table Versioned SQL V5_4__ remove document column on handovers and transfers table.sql 00:00.017s
5.5 add approval on handover table Versioned SQL V5_5__add approval on handover table.sql 00:00.039s
Flyway Exception: Migration V6__remove equipment user many to many relationship.sql failed
------------------------------------------------------------------------
SQL State  : 42000
Error Code : 1091
Message    : (conn=220) Can't DROP COLUMN `document`; check that it exists
Location   : src\main\resources\db\migration\V6__remove equipment user many to many relationship.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V6__remove equipment user many to many relationship.sql)
Line       : 9
Statement  : ALTER TABLE handovers
    DROP COLUMN document
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 10
32 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:02.779s
Database version: 10
32 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:02.779s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
1 Versioned SQL V1__.sql 00:00.904s
1.1 Versioned SQL V1_1__.sql 00:00.011s
2 add file storage table Versioned SQL V2__add file storage table.sql 00:00.009s
2.1 remove created at and updated at Versioned SQL V2_1__ remove created at and updated at.sql 00:00.125s
2.2 rename acceptance date to approval date Versioned SQL V2_2__ rename acceptance_date to approval_date.sql 00:00.019s
2.3 remove equipment status and handover status from handovers table Versioned SQL V2_3__ remove equipment_status and handover_status from handovers table.sql 00:00.020s
2.4 create equipment user table Versioned SQL V2_4__ create equipment_user table.sql 00:00.039s
2.5 Versioned SQL V2_5__.sql 00:00.028s
2.6 remove image field in repair table Versioned SQL V2.6__remove image field in repair table.sql 00:00.011s
2.7 change associated entity id type from string to long Versioned SQL V2_7__ change associated entity id type from string to long.sql 00:00.018s
2.8 add content type in file storage table Versioned SQL V2_8__ add content type in file storage table.sql 00:00.023s
2.9 add password field to user table Versioned SQL V2_9__ add password field to user table.sql 00:00.080s
3 add forgot password table Versioned SQL V3__ add forgot password table.sql 00:00.021s
3.3 remove inventory status Versioned SQL V3_3__ remove inventory status.sql 00:00.016s
4 add equipment group table Versioned SQL V4__add equipment group table.sql 00:00.026s
4.1 update not null constraint on equipment categories table and equipment groups table Versioned SQL V4_1__update not null constraint on equipment categories table and equipment groups table.sql 00:00.080s
4.2 Versioned SQL V4_2__.sql 00:00.029s
4.3 drop unique on alias in equipment categories table Versioned SQL V4_3__drop unique on alias in equipment categories table.sql 00:00.020s
5 create equipment unit table Versioned SQL V5__create equipment unit table.sql 00:00.038s
5.1 drop unique constraint on hash code Versioned SQL V5_1__drop unique constraint on hash_code.sql 00:00.012s
5.2 add created by in handovers table Versioned SQL V5_2__ add created by in handovers table.sql 00:00.034s
5.4 remove document column on handovers and transfers table Versioned SQL V5_4__ remove document column on handovers and transfers table.sql 00:00.017s
5.5 add approval on handover table Versioned SQL V5_5__add approval on handover table.sql 00:00.033s
6 remove equipment user many to many relationship Versioned SQL V6__remove equipment user many to many relationship.sql 00:00.030s
7 add notification, notification config and user read notification table Versioned SQL V7__add notification, notification config and user read notification table.sql 00:00.048s
7.1 modify notifications content from text to json Versioned SQL V7_1__modify notifications content from text to json.sql 00:00.009s
7.2 add note filed to handovers table Versioned SQL V7_2__ add note filed to handovers table.sql 00:00.018s
7.3 alter notification and notification config table Versioned SQL V7_3__ alter notification and notification config table.sql 00:00.055s
7.4 add note and status on handovers table Versioned SQL V7_4__ add note and status on handovers table.sql 00:00.038s
8 modify all data type from date to datetime Versioned SQL V8__ modify all data type from date to datetime.sql 00:00.293s
9 add repair ticket, broken report ticket, ticket processes, add not null constraint on some local date time data type Versioned SQL V9__add repair ticket, broken report ticket, ticket processes, add not null constraint on some local date time data type.sql 00:00.384s
10 drop all ticket processes table Versioned SQL V10__ drop all ticket processes table.sql 00:00.291s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 10.1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.101s
Database version: 10.1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.101s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
10.1 add priority to broken report ticket table Versioned SQL V10_1__ add priority to broken report ticket table.sql 00:00.101s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 10.2
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.044s
Database version: 10.2
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.044s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
10.2 rename broken report ticket to report broken tickets Versioned SQL V10_2__rename broken_report_ticket to report_broken_tickets.sql 00:00.044s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 10.4
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.023s
Database version: 10.4
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.023s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
10.4 add repair note Versioned SQL V10_4__add repair note.sql 00:00.023s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 10.5
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.060s
Database version: 10.5
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.060s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
10.5 add acceptance tester id on repair ticket table Versioned SQL V10_5__ add acceptance tester id on repair ticket table.sql 00:00.060s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 10.6
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.032s
Database version: 10.6
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.032s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
10.6 add acceptance test date Versioned SQL V10_6__ add acceptance test date .sql 00:00.032s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 11
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.186s
Database version: 11
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.186s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
11 alter transfer class to extend ticket class Versioned SQL V11__ alter transfer class to extend ticket class.sql 00:00.186s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 12
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.220s
Database version: 12
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.220s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
12 alter liquidations table Versioned SQL V12__alter liquidations table.sql 00:00.220s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 13
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.049s
Database version: 13
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.049s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
13 rename to maintenance tickets and transfer tickets Versioned SQL V13__ rename to maintenance_tickets and transfer_tickets.sql 00:00.049s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 14
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.193s
Database version: 14
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.193s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
14 add some fields to maintenance table Versioned SQL V14__add some fields to maintenance table.sql 00:00.193s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 14.1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.023s
Database version: 14.1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.023s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
14.1 drop maintenance status Versioned SQL V14_1__ drop maintenance status.sql 00:00.023s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 14.2
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.032s
Database version: 14.2
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.032s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
14.2 add next time maintenances Versioned SQL V14_2__add next time maintenances.sql 00:00.032s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 14.3
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.030s
Database version: 14.3
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.030s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
14.3 remove next time in maintenance tickets taable Versioned SQL V14_3__ remove next time in maintenance tickets taable.sql 00:00.030s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 14.4
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.196s
Database version: 14.4
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.196s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
14.4 add not null constraint on some field in equipments table Versioned SQL V14_4__ add not null constraint on some field in equipments table.sql 00:00.196s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 14.5
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.046s
Database version: 14.5
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.046s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
14.5 add coloumn maintenance company id on maintenance table Versioned SQL V14_5__ add coloumn maintenance company id on maintenance table.sql 00:00.046s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 15
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.180s
Database version: 15
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.180s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
15 alter inspection class to extend ticket class Versioned SQL V15__ alter inspection class to extend ticket class.sql 00:00.180s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 15.1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.011s
Database version: 15.1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.011s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
15.1 rename inspections table to inspection tickets Versioned SQL V15_1__ rename inspections table to inspection_tickets.sql 00:00.011s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 15.2
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.022s
Database version: 15.2
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.022s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
15.2 rename maintenance company id to inspection company id Versioned SQL V15_2__rename maintenance company id to inspection company id.sql 00:00.022s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 15.3
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.015s
Database version: 15.3
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.015s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
15.3 add inspection evaluation status Versioned SQL V15_3__add inspection evaluation status.sql 00:00.015s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 15.4
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.014s
Database version: 15.4
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.014s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
15.4 drop not null constraint on last time in inspection tickets table Versioned SQL V15_4__drop not null constraint on last_time in inspection_tickets table.sql 00:00.014s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 15.5
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.018s
Database version: 15.5
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.018s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
15.5 rename table liquidations to liquidation tickets Versioned SQL V15_5__rename table liquidations to liquidation_tickets.sql 00:00.018s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 15.6
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.035s
Database version: 15.6
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.035s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
15.6 rename handovers to handover tickets Versioned SQL V15_6__rename handovers to handover_tickets.sql 00:00.035s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
You can read more about the migrate report here

No migrations found

Flyway Exception: Migration V16__ handover ticket entity now extend ticket class.sql failed
-------------------------------------------------------------------------
SQL State  : 22007
Error Code : 1292
Message    : (conn=589) Incorrect datetime value: '' for column `mdm_equipment`.`handover_tickets`.`created_date` at row 1
Location   : src\main\resources\db\migration\V16__ handover ticket entity now extend ticket class.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V16__ handover ticket entity now extend ticket class.sql)
Line       : 22
Statement  : UPDATE handover_tickets
SET created_date = ''
WHERE created_date IS NULL
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
You can read more about the migrate report here

No migrations found

Flyway Exception: Migration V16__ handover ticket entity now extend ticket class.sql failed
-------------------------------------------------------------------------
SQL State  : 42S21
Error Code : 1060
Message    : (conn=592) Duplicate column name 'code'
Location   : src\main\resources\db\migration\V16__ handover ticket entity now extend ticket class.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V16__ handover ticket entity now extend ticket class.sql)
Line       : 1
Statement  : ALTER TABLE handover_tickets
    ADD code VARCHAR(255) NULL
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 16
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.099s
Database version: 16
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.099s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
16 handover ticket entity now extend ticket class Versioned SQL V16__ handover ticket entity now extend ticket class.sql 00:00.099s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 16.1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.037s
Database version: 16.1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.037s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
16.1 drop department on handover ticket table Versioned SQL V16_1__drop department on handover ticket table.sql 00:00.037s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 17
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.109s
Database version: 17
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.109s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
17 remove clinic inspection, cv radiation, external assessment, radiation inspection Versioned SQL V17__remove clinic inspection, cv radiation, external assessment, radiation inspection.sql 00:00.109s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 18
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.062s
Database version: 18
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.062s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
18 add department id to handover table Versioned SQL V18__add department id to handover table.sql 00:00.062s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 18.1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.056s
Database version: 18.1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.056s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
18.1 add report broken ticket id field to repair table Versioned SQL V18_1__add report broken ticket id field to repair table.sql 00:00.056s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 18.2
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.077s
Database version: 18.2
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.077s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
18.2 remove report broken ticket id and add not null on equipment unit name field Versioned SQL V18_2__remove report broken ticket id and add not null on equipment unit name field.sql 00:00.077s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 19
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.275s
Database version: 19
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.275s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
19 Versioned SQL V19__.sql 00:00.275s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
You can read more about the migrate report here

No migrations found

Flyway Exception: Migration V20__.sql failed
--------------------------
SQL State  : 22007
Error Code : 1292
Message    : (conn=180) Truncated incorrect INTEGER value: 'DDT'
Location   : src\main\resources\db\migration\V20__.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V20__.sql)
Line       : 1
Statement  : ALTER TABLE notification_configs
    CHANGE role_can_receive_notification role_id BIGINT
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
You can read more about the migrate report here

No migrations found

Flyway Exception: Migration V20__.sql failed
--------------------------
SQL State  : HY000
Error Code : 1830
Message    : (conn=183) Column 'department_id' cannot be NOT NULL: needed in a foreign key constraint 'mdm_equipment/FK_HANDOVER_TICKETS_ON_DEPARTMENT' SET NULL
Location   : src\main\resources\db\migration\V20__.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V20__.sql)
Line       : 10
Statement  : ALTER TABLE handover_tickets
    MODIFY department_id BIGINT NOT NULL
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
Database version: 0
0 scripts migrated
Database Schema: mdm_equipment
Execution Time: 00:00.000s
You can read more about the migrate report here

No migrations found

Flyway Exception: Migration V20__update notification configs table, rename role_can_receive notification to role id.sql failed
------------------------------------------------------------------------------------------------------------
SQL State  : 42S22
Error Code : 1054
Message    : (conn=186) Unknown column 'role_can_receive_notification' in 'notification_configs'
Location   : src\main\resources\db\migration\V20__update notification configs table, rename role_can_receive notification to role id.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V20__update notification configs table, rename role_can_receive notification to role id.sql)
Line       : 1
Statement  : ALTER TABLE notification_configs
    CHANGE role_can_receive_notification role_id BIGINT
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 20
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.016s
Database version: 20
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.016s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
20 update notification configs table, rename role can receive notification to role id Versioned SQL V20__update notification configs table, rename role_can_receive notification to role id.sql 00:00.016s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 20.1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.023s
Database version: 20.1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.023s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
20.1 add foreign key constraint on role table Versioned SQL V20_1__add foreign key constraint on role table.sql 00:00.023s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 21
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.036s
Database version: 21
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.036s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
21 add supply group table Versioned SQL V21__add supply group table.sql 00:00.036s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 22
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.124s
Database version: 22
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.124s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
22 drop supply groups Versioned SQL V22__drop supply groups.sql 00:00.124s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 22.1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.030s
Database version: 22.1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.030s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
22.1 remove audit on supplies table Versioned SQL V22_1__remove audit on supplies table.sql 00:00.030s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 22.3
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.073s
Database version: 22.3
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.073s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
22.3 drop unique indexes Versioned SQL V22_3__drop unique indexes.sql 00:00.073s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 22.4
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.029s
Database version: 22.4
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.029s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
22.4 drop column code on supplies table Versioned SQL V22_4__drop column code on supplies table.sql 00:00.029s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 22.5
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.013s
Database version: 22.5
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.013s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
22.5 drop column status on supply Versioned SQL V22_5__drop column status on supply.sql 00:00.013s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 23
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.052s
Database version: 23
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.052s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
23 add last maintenance date and last inspection date Versioned SQL V23__add last maintenance date and last inspection date.sql 00:00.052s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet

Migration report
Database version: 23.1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.020s
Database version: 23.1
1 script migrated
Database Schema: mdm_equipment
Execution Time: 00:00.020s
You can read more about the migrate report here
Version Description Category Type Filepath ExecutionTime
23.1 rename last time inspection to inspection date, and same with maintenance Versioned SQL V23_1__rename last time inspection to inspection date, and same with maintenance.sql 00:00.020s
Explore how to get this report and what it can do for you.

Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.

Explore how to get this report and what it can do for you.

Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.

Explore how to get this report and what it can do for you.

No code analysis report available yet